<?php
declare (strict_types=1);

namespace app\sysuser\controller\core;

use app\common\controller\SysBackend;
use app\common\model\banxi\core\CoreVocabularyLexicon as CoreVocabularyLexiconModel;
use app\common\service\ImportService;
use app\common\service\queue\QueueService;
use think\db\exception\DbException;
use think\exception\ValidateException;
use think\facade\Validate;
use think\validate\ValidateRule;

class CoreVocabularyLexicon extends SysBackend
{
    protected array $noNeedLogin = [];
    protected array $noNeedPermission = [];

    public function initialize(): void
    {
        parent::initialize();
        $this->model = new CoreVocabularyLexiconModel();
    }


    /**
     * 分页查询
     * @return void
     * @throws DbException
     */
    public function listPage(): void
    {
        $param = $this->request->param(['index', 'limit', 'orderBy', "query"]);
        //查询条件解析
        $where = get_query($param);
        //获取分页数据
        $pageParams = get_page_params($param);
        $list = $this->model->where($where)
            ->paginate([
                'page' => $pageParams['page'],
                'list_rows' => $pageParams['limit']
            ]);
        $this->ok('操作成功', result_row($list));
    }

    /**
     * 查询
     * @return void
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public function get()
    {
        $param = $this->request->param(["query" => []]);
        if (empty($param['query'])) {
            $this->fail('请传递你要查询的记录');
        }
        $where = get_query($param);
        $info = $this->model
            ->with(['rangeList'])
            ->where($where)
            ->find();
        if (empty($info)) {
            $this->fail('记录不存在');
        }
        $this->ok('操作成功', removeNull($info));
    }

    public function saveOrUpdate()
    {
        $param = $this->request->param();
        try {
            $model = $param;
            $model['option'] = json_encode($param['optionList'] ?? []);
            $model['answer'] = json_encode($param['answerList'] ?? []);
            $this->model->saveOrUpdateLexicon($model);
            $queueService = new QueueService();
            $queueService->addWordVocalJob();
        } catch (ValidateException $exception) {
            $this->fail($exception->getMessage());
        }
        $this->ok('操作成功', [], self::NOTIFICATION);
    }

    public function del()
    {
        $param = $this->request->param(['ids' => []]);
        try {
            $validate = Validate::rule([
                'ids' => ValidateRule::isRequire(null, '请选择你要删除的记录'),
            ]);
            if (!$validate->check($param)) throw new ValidateException($validate->getError());
            CoreVocabularyLexiconModel::destroy(function ($query) use ($param) {
                $query->whereIn('id', $param['ids']);
            });
        } catch (ValidateException $exception) {
            $this->fail($exception->getMessage());
        }
        $this->ok('操作成功', [], self::NOTIFICATION);
    }


    public function importExcel()
    {
        try {
            $file = $this->request->file('file');
            $param = $this->request->param(['settingId']);
            $importService = new ImportService();
            $importService->vocabularyLexiconImport($file, $param['settingId']);
            $queueService = new QueueService();
            $queueService->addWordVocalJob();
        } catch (ValidateException $exception) {
            $this->fail($exception->getMessage());
        }
        $this->ok('操作成功', [], self::NOTIFICATION);
    }
}
